[dbo].[sp_asi_GetLastFirst]

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)	Direction
@LastName	varchar(30)	30
@FirstName	varchar(20)	20
@LastFirst	varchar(30)	30	Out

Type	Action	Owning Principal
Grant	Execute	IMIS

SQL Script

/****** Object:  StoredProcedure dbo.sp_asi_GetLastFirst  ******/

-- =============================================
-- This stored procedure calculates LastFirst based on the input parameters.
-- Input parameters are LastName, FirstName.
-- Output parameter is LastFirst.
-- By default, LastFirst is calculated to
-- @LastName + ', ' + @FirstName
-- if both parameters are not empty strings, otherwise
-- @LastName + ' ' + @FirstName
-- =============================================
CREATE PROCEDURE [dbo].[sp_asi_GetLastFirst]
    @LastName varchar(30) = NULL,
    @FirstName varchar(20) = NULL,
    @LastFirst varchar(30) OUTPUT
AS
BEGIN
    SET @LastFirst = dbo.fn_asi_GetLastFirst(@LastName, @FirstName)
    SELECT @LastFirst as LastFirst
END

GO
GRANT EXECUTE ON  [dbo].[sp_asi_GetLastFirst] TO [IMIS]
GO